﻿CREATE TABLE [Mapping].[Category]
(
	[Id] INT NOT NULL PRIMARY KEY NONCLUSTERED IDENTITY, 
  [CategoryName] NVARCHAR(20) NOT NULL, 
  [Description] NVARCHAR(200) NULL, 
  [HierarchyId] [sys].[hierarchyid] NULL
)

GO

CREATE CLUSTERED INDEX [IX_HierarchyId] ON [Mapping].[Category] ([HierarchyId])
